<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html lang="en">

<head>
  <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  <title>LCOV - coverage_clean.info - home/liying/sqlcc/src/dcl_test.cpp</title>
  <link rel="stylesheet" type="text/css" href="../../../../gcov.css">
</head>

<body>

          <table width="100%" border=0 cellspacing=0 cellpadding=0>
            <tr><td class="title">LCOV - code coverage report</td></tr>
            <tr><td class="ruler"><img src="../../../../glass.png" width=3 height=3 alt=""></td></tr>

            <tr>
              <td width="100%">
                <table cellpadding=1 border=0 width="100%">
          <tr>
            <td width="10%" class="headerItem">Current view:</td>
            <td width="10%" class="headerValue"><a href="../../../../index.html">top level</a> - <a href="index.html">/home/liying/sqlcc/src</a> - dcl_test.cpp<span style="font-size: 80%;"> (source / <a href="dcl_test.cpp.func-c.html">functions</a>)</span></td>
            <td width="5%"></td>
            <td width="5%"></td>
            <td width="5%" class="headerCovTableHead">Coverage</td>
            <td width="5%" class="headerCovTableHead" title="Covered + Uncovered code">Total</td>
            <td width="5%" class="headerCovTableHead" title="Exercised code only">Hit</td>
          </tr>
          <tr>
            <td class="headerItem">Test:</td>
            <td class="headerValue">coverage_clean.info</td>
            <td></td>
            <td class="headerItem">Lines:</td>
            <td class="headerCovTableEntryHi">91.1&nbsp;%</td>
            <td class="headerCovTableEntry">45</td>
            <td class="headerCovTableEntry">41</td>
          </tr>
          <tr>
            <td class="headerItem">Test Date:</td>
            <td class="headerValue">2025-11-25 04:45:29</td>
            <td></td>
            <td class="headerItem">Functions:</td>
            <td class="headerCovTableEntryHi">100.0&nbsp;%</td>
            <td class="headerCovTableEntry">3</td>
            <td class="headerCovTableEntry">3</td>
          </tr>
                  <tr><td><img src="../../../../glass.png" width=3 height=3 alt=""></td></tr>
                </table>
              </td>
            </tr>

            <tr><td class="ruler"><img src="../../../../glass.png" width=3 height=3 alt=""></td></tr>
          </table>

          <table cellpadding=0 cellspacing=0 border=0>
            <tr>
              <td><br></td>
            </tr>
            <tr>
              <td>
<pre class="sourceHeading">            Line data    Source code</pre>
<pre class="source">
<span id="L1"><span class="lineNum">       1</span>              : #include &lt;iostream&gt;</span>
<span id="L2"><span class="lineNum">       2</span>              : #include &lt;fstream&gt;</span>
<span id="L3"><span class="lineNum">       3</span>              : #include &lt;string&gt;</span>
<span id="L4"><span class="lineNum">       4</span>              : #include &quot;../include/sql_executor.h&quot;</span>
<span id="L5"><span class="lineNum">       5</span>              : </span>
<span id="L6"><span class="lineNum">       6</span>              : // 读取SQL文件内容</span>
<span id="L7"><span class="lineNum">       7</span> <span class="tlaGNC tlaBgGNC">           1 : std::string readSqlFile(const std::string&amp; filename) {</span></span>
<span id="L8"><span class="lineNum">       8</span> <span class="tlaGNC">           1 :     std::ifstream file(filename);</span></span>
<span id="L9"><span class="lineNum">       9</span> <span class="tlaGNC">           1 :     if (!file.is_open()) {</span></span>
<span id="L10"><span class="lineNum">      10</span> <span class="tlaUNC tlaBgUNC">           0 :         return &quot;Error: Cannot open file &quot; + filename;</span></span>
<span id="L11"><span class="lineNum">      11</span>              :     }</span>
<span id="L12"><span class="lineNum">      12</span>              :     </span>
<span id="L13"><span class="lineNum">      13</span>              :     std::string content((std::istreambuf_iterator&lt;char&gt;(file)), </span>
<span id="L14"><span class="lineNum">      14</span> <span class="tlaGNC tlaBgGNC">           1 :                         std::istreambuf_iterator&lt;char&gt;());</span></span>
<span id="L15"><span class="lineNum">      15</span> <span class="tlaGNC">           1 :     file.close();</span></span>
<span id="L16"><span class="lineNum">      16</span> <span class="tlaGNC">           1 :     return content;</span></span>
<span id="L17"><span class="lineNum">      17</span> <span class="tlaGNC">           1 : }</span></span>
<span id="L18"><span class="lineNum">      18</span>              : </span>
<span id="L19"><span class="lineNum">      19</span>              : // 分割SQL语句</span>
<span id="L20"><span class="lineNum">      20</span> <span class="tlaGNC">           1 : std::vector&lt;std::string&gt; splitSqlStatements(const std::string&amp; sqlContent) {</span></span>
<span id="L21"><span class="lineNum">      21</span> <span class="tlaGNC">           1 :     std::vector&lt;std::string&gt; statements;</span></span>
<span id="L22"><span class="lineNum">      22</span> <span class="tlaGNC">           1 :     std::string currentStatement;</span></span>
<span id="L23"><span class="lineNum">      23</span>              :     </span>
<span id="L24"><span class="lineNum">      24</span> <span class="tlaGNC">         564 :     for (size_t i = 0; i &lt; sqlContent.length(); ++i) {</span></span>
<span id="L25"><span class="lineNum">      25</span>              :         // 跳过注释</span>
<span id="L26"><span class="lineNum">      26</span> <span class="tlaGNC">         563 :         if (i &lt; sqlContent.length() - 1 &amp;&amp; sqlContent[i] == '-' &amp;&amp; sqlContent[i+1] == '-') {</span></span>
<span id="L27"><span class="lineNum">      27</span> <span class="tlaGNC">         450 :             while (i &lt; sqlContent.length() &amp;&amp; sqlContent[i] != '\n') {</span></span>
<span id="L28"><span class="lineNum">      28</span> <span class="tlaGNC">         436 :                 ++i;</span></span>
<span id="L29"><span class="lineNum">      29</span>              :             }</span>
<span id="L30"><span class="lineNum">      30</span> <span class="tlaGNC">          14 :             continue;</span></span>
<span id="L31"><span class="lineNum">      31</span>              :         }</span>
<span id="L32"><span class="lineNum">      32</span>              :         </span>
<span id="L33"><span class="lineNum">      33</span> <span class="tlaGNC">         549 :         currentStatement += sqlContent[i];</span></span>
<span id="L34"><span class="lineNum">      34</span>              :         </span>
<span id="L35"><span class="lineNum">      35</span>              :         // 检测分号作为语句结束符</span>
<span id="L36"><span class="lineNum">      36</span> <span class="tlaGNC">         549 :         if (sqlContent[i] == ';') {</span></span>
<span id="L37"><span class="lineNum">      37</span>              :             // 去除前后空白字符</span>
<span id="L38"><span class="lineNum">      38</span> <span class="tlaGNC">          14 :             size_t start = currentStatement.find_first_not_of(&quot; \t\n\r&quot;);</span></span>
<span id="L39"><span class="lineNum">      39</span> <span class="tlaGNC">          14 :             size_t end = currentStatement.find_last_not_of(&quot; \t\n\r&quot;);</span></span>
<span id="L40"><span class="lineNum">      40</span> <span class="tlaGNC">          14 :             if (start != std::string::npos &amp;&amp; end != std::string::npos) {</span></span>
<span id="L41"><span class="lineNum">      41</span> <span class="tlaGNC">          14 :                 statements.push_back(currentStatement.substr(start, end - start + 1));</span></span>
<span id="L42"><span class="lineNum">      42</span>              :             }</span>
<span id="L43"><span class="lineNum">      43</span> <span class="tlaGNC">          14 :             currentStatement.clear();</span></span>
<span id="L44"><span class="lineNum">      44</span>              :         }</span>
<span id="L45"><span class="lineNum">      45</span>              :     }</span>
<span id="L46"><span class="lineNum">      46</span>              :     </span>
<span id="L47"><span class="lineNum">      47</span> <span class="tlaGNC">           2 :     return statements;</span></span>
<span id="L48"><span class="lineNum">      48</span> <span class="tlaGNC">           1 : }</span></span>
<span id="L49"><span class="lineNum">      49</span>              : </span>
<span id="L50"><span class="lineNum">      50</span> <span class="tlaGNC">           1 : int main() {</span></span>
<span id="L51"><span class="lineNum">      51</span> <span class="tlaGNC">           1 :     std::cout &lt;&lt; &quot;=== DCL（数据控制语言）测试开始 ===&quot; &lt;&lt; std::endl;</span></span>
<span id="L52"><span class="lineNum">      52</span>              :     </span>
<span id="L53"><span class="lineNum">      53</span>              :     // 创建SQL执行器实例</span>
<span id="L54"><span class="lineNum">      54</span> <span class="tlaGNC">           1 :     sqlcc::SqlExecutor executor;</span></span>
<span id="L55"><span class="lineNum">      55</span>              :     </span>
<span id="L56"><span class="lineNum">      56</span>              :     // 读取DCL测试脚本</span>
<span id="L57"><span class="lineNum">      57</span> <span class="tlaGNC">           1 :     std::string sqlContent = readSqlFile(&quot;../scripts/sql/dcl_test_script.sql&quot;);</span></span>
<span id="L58"><span class="lineNum">      58</span>              :     </span>
<span id="L59"><span class="lineNum">      59</span> <span class="tlaGNC">           1 :     if (sqlContent.substr(0, 5) == &quot;Error&quot;) {</span></span>
<span id="L60"><span class="lineNum">      60</span> <span class="tlaUNC tlaBgUNC">           0 :         std::cerr &lt;&lt; sqlContent &lt;&lt; std::endl;</span></span>
<span id="L61"><span class="lineNum">      61</span> <span class="tlaUNC">           0 :         return 1;</span></span>
<span id="L62"><span class="lineNum">      62</span>              :     }</span>
<span id="L63"><span class="lineNum">      63</span>              :     </span>
<span id="L64"><span class="lineNum">      64</span>              :     // 分割并执行SQL语句</span>
<span id="L65"><span class="lineNum">      65</span> <span class="tlaGNC tlaBgGNC">           1 :     std::vector&lt;std::string&gt; statements = splitSqlStatements(sqlContent);</span></span>
<span id="L66"><span class="lineNum">      66</span>              :     </span>
<span id="L67"><span class="lineNum">      67</span> <span class="tlaGNC">           1 :     std::cout &lt;&lt; &quot;共读取到 &quot; &lt;&lt; statements.size() &lt;&lt; &quot; 条SQL语句&quot; &lt;&lt; std::endl;</span></span>
<span id="L68"><span class="lineNum">      68</span>              :     </span>
<span id="L69"><span class="lineNum">      69</span> <span class="tlaGNC">          15 :     for (size_t i = 0; i &lt; statements.size(); ++i) {</span></span>
<span id="L70"><span class="lineNum">      70</span> <span class="tlaGNC">          14 :         std::cout &lt;&lt; &quot;\n执行语句 &quot; &lt;&lt; (i + 1) &lt;&lt; &quot;:&quot; &lt;&lt; std::endl;</span></span>
<span id="L71"><span class="lineNum">      71</span> <span class="tlaGNC">          14 :         std::cout &lt;&lt; statements[i] &lt;&lt; std::endl;</span></span>
<span id="L72"><span class="lineNum">      72</span>              :         </span>
<span id="L73"><span class="lineNum">      73</span> <span class="tlaGNC">          14 :         std::string result = executor.Execute(statements[i]);</span></span>
<span id="L74"><span class="lineNum">      74</span> <span class="tlaGNC">          14 :         std::cout &lt;&lt; &quot;结果: &quot; &lt;&lt; result &lt;&lt; std::endl;</span></span>
<span id="L75"><span class="lineNum">      75</span>              :         </span>
<span id="L76"><span class="lineNum">      76</span>              :         // 检查是否有错误</span>
<span id="L77"><span class="lineNum">      77</span> <span class="tlaGNC">          14 :         if (result.find(&quot;Error&quot;) != std::string::npos &amp;&amp; result.find(&quot;Error: Cannot open file&quot;) == std::string::npos) {</span></span>
<span id="L78"><span class="lineNum">      78</span> <span class="tlaUNC tlaBgUNC">           0 :             std::cout &lt;&lt; &quot;警告: 语句执行可能存在问题&quot; &lt;&lt; std::endl;</span></span>
<span id="L79"><span class="lineNum">      79</span>              :         }</span>
<span id="L80"><span class="lineNum">      80</span> <span class="tlaGNC tlaBgGNC">          14 :     }</span></span>
<span id="L81"><span class="lineNum">      81</span>              :     </span>
<span id="L82"><span class="lineNum">      82</span> <span class="tlaGNC">           1 :     std::cout &lt;&lt; &quot;\n=== DCL测试完成 ===&quot; &lt;&lt; std::endl;</span></span>
<span id="L83"><span class="lineNum">      83</span> <span class="tlaGNC">           1 :     return 0;</span></span>
<span id="L84"><span class="lineNum">      84</span> <span class="tlaGNC">           1 : }</span></span>
        </pre>
              </td>
            </tr>
          </table>
          <br>

          <table width="100%" border=0 cellspacing=0 cellpadding=0>
            <tr><td class="ruler"><img src="../../../../glass.png" width=3 height=3 alt=""></td></tr>
            <tr><td class="versionInfo">Generated by: <a href="https://github.com//linux-test-project/lcov" target="_parent">LCOV version 2.0-1</a></td></tr>
          </table>
          <br>

</body>
</html>
